Computer Science for IGCSE & O level - Databases (Section 4 - No. 48)
What does the `WHERE` clause do in an SQL query?
Sorts the results in ascending order.
Specifies the tables to retrieve data from.
Filters the data based on specified conditions.
Groups data based on a specific column.
Explication
The `WHERE` clause filters the data, retrieving only rows that satisfy the condition specified.